Executive Master in Strategic Finance and Business Leadership

MS Excel Beginners Course    

Course ID:   260518 0106 616ESH

Course Dates :          18/05/2026             Course Duration :   5   Studying Day/s   Course Location: London,   United Kingdom

Language:  Bilingual

Course Category:  Computer Science Programmes

Course Subcategories:

Advanced Excel & Modelling Data Analysis Data Science Information Systems Programming & Development Systems Architecture

Course Certified By:  ESHub CPD & LondonUni - Executive Management Training

* Professional Training and CPD Programs

Certification Will Be Issued:  From London, United Kingdom


Course Fees: 

VAT varies by course location and participant nationality.

Date has passed please contact us Sales@e-s-hub.com

Introduction

Microsoft Excel is one of the most widely used applications for organising information, performing calculations, analysing data, and producing professional reports. Whether used in administration, finance, operations, sales, or project management, strong Excel skills improve productivity, reduce manual work, and support better business decisions.

This five-day course introduces the essential features of Microsoft Excel through practical, hands-on exercises. Participants will learn how to create worksheets, enter and format data, use basic formulas and functions, organise information, create charts, and prepare professional spreadsheets that can be used immediately in the workplace.

Objectives

1. Create and manage Excel workbooks and worksheets using standard formatting and navigation techniques.
2. Enter, organise, and format data to produce clear and professional spreadsheets.
3. Perform calculations using basic formulas and commonly used Excel functions.
4. Sort, filter, and analyse simple datasets and present information using charts and tables.
5. Prepare, print, and share Excel worksheets suitable for everyday business use.

Who Should Attend

1. Administrative Assistants and Office Staff.
2. Finance, Accounting, and Payroll Assistants.
3. Sales, Customer Service, and Operations Personnel.
4. Supervisors and Team Leaders who prepare routine reports.
5. Anyone with little or no prior experience using Microsoft Excel.

Training Method

• Pre-assessment
• Live group instruction
• Use of real-world examples, case studies and exercises
• Interactive participation and discussion
• Power point presentation, LCD and flip chart
• Group activities and tests
• Post-assessment
If Applicable:
• Each participant receives a 7” Tablet containing a copy of the presentation, slides and handouts

Program Support

This program is supported by:
* Interactive discussions
* Role-play
* Case studies and highlight the techniques available to the participants.

Course Agenda

Daily Schedule (Monday to Friday)
- 09:00 AM – 10:30 AM Technical Session 1
- 10:30 AM – 12:00 PM Technical Session 2
- 12:00 PM – 01:00 PM Technical Session 3
- 01:00 PM – 02:00 PM Lunch Break (If Applicable)
- Participants are expected to engage in guided self-study, reading, or personal reflection on the day’s content. This contributes toward the CPD accreditation and deepens conceptual understanding.
- 02:00 PM – 04:00 PM Self-Study & Reflection

Please Note:
- All training sessions are conducted from Monday to Friday, following the standard working week observed in the United Kingdom and European Union. Saturday and Sunday are official weekends and are not counted as part of the course duration.
- Coffee and refreshments are available on a floating basis throughout the morning. Participants may help themselves at their convenience to ensure an uninterrupted learning experience Provided if applicable and subject to course delivery arrangements.
- Lunch Provided if applicable and subject to course delivery arrangements.

Week 1

Day 1 – Getting Started with Microsoft Excel

1. Introduction to Excel
- Understanding the Excel interface
- Creating and saving workbooks
- Navigating worksheets and cells

2. Working with Data
- Entering and editing data
- Using AutoFill and basic formatting
- Managing rows, columns, and worksheets

3. Workbook Organisation
- Renaming worksheets
- Moving and copying data
- Applying basic page layouts

Day 2 – Formulas and Functions

1. Basic Formulas
- Mathematical calculations
- Cell references
- Formula copying techniques

2. Essential Functions
- SUM, AVERAGE, MIN, and MAX
- COUNT and COUNTA
- Basic IF function

3. Formatting Data
- Number formats
- Cell styles
- Conditional formatting basics

Day 3 – Managing Data

1. Organising Information
- Creating Excel tables
- Sorting records
- Filtering data

2. Data Validation
- Creating drop-down lists
- Preventing invalid entries
- Input messages and error alerts

3. Finding Information
- Using Find and Replace
- Navigating large worksheets
- Managing worksheet views

Day 4 – Charts and Printing

1. Creating Charts
- Column and bar charts
- Line and pie charts
- Selecting appropriate chart types

2. Formatting Charts
- Editing chart elements
- Adding titles and labels
- Improving chart readability

3. Printing Worksheets
- Page setup
- Print areas
- Headers, footers, and scaling

Day 5 – Practical Excel Workshop

1. Spreadsheet Development Exercise
- Creating a business worksheet
- Applying formulas and formatting
- Organising data effectively

2. Reporting Exercise
- Sorting and filtering information
- Creating charts
- Preparing a printable report

3. Implementation Planning
- Applying Excel skills to daily work
- Identifying opportunities for automation
- Course review, feedback and implementation planning

Executive Master in Strategic Finance and Business Leadership

Course Information

Introduction

Microsoft Excel is one of the most widely used applications for organising information, performing calculations, analysing data, and producing professional reports. Whether used in administration, finance, operations, sales, or project management, strong Excel skills improve productivity, reduce manual work, and support better business decisions.

This five-day course introduces the essential features of Microsoft Excel through practical, hands-on exercises. Participants will learn how to create worksheets, enter and format data, use basic formulas and functions, organise information, create charts, and prepare professional spreadsheets that can be used immediately in the workplace.

Objectives

1. Create and manage Excel workbooks and worksheets using standard formatting and navigation techniques.
2. Enter, organise, and format data to produce clear and professional spreadsheets.
3. Perform calculations using basic formulas and commonly used Excel functions.
4. Sort, filter, and analyse simple datasets and present information using charts and tables.
5. Prepare, print, and share Excel worksheets suitable for everyday business use.

Who Should Attend?

1. Administrative Assistants and Office Staff.
2. Finance, Accounting, and Payroll Assistants.
3. Sales, Customer Service, and Operations Personnel.
4. Supervisors and Team Leaders who prepare routine reports.
5. Anyone with little or no prior experience using Microsoft Excel.

Training Method

• Pre-assessment
• Live group instruction
• Use of real-world examples, case studies and exercises
• Interactive participation and discussion
• Power point presentation, LCD and flip chart
• Group activities and tests
• Post-assessment
If Applicable:
• Each participant receives a 7” Tablet containing a copy of the presentation, slides and handouts

Program Support

This program is supported by:
* Interactive discussions
* Role-play
* Case studies and highlight the techniques available to the participants.

Daily Agenda

Daily Schedule (Monday to Friday)
- 09:00 AM – 10:30 AM Technical Session 1
- 10:30 AM – 12:00 PM Technical Session 2
- 12:00 PM – 01:00 PM Technical Session 3
- 01:00 PM – 02:00 PM Lunch Break (If Applicable)
- Participants are expected to engage in guided self-study, reading, or personal reflection on the day’s content. This contributes toward the CPD accreditation and deepens conceptual understanding.
- 02:00 PM – 04:00 PM Self-Study & Reflection

Please Note:
- All training sessions are conducted from Monday to Friday, following the standard working week observed in the United Kingdom and European Union. Saturday and Sunday are official weekends and are not counted as part of the course duration.
- Coffee and refreshments are available on a floating basis throughout the morning. Participants may help themselves at their convenience to ensure an uninterrupted learning experience Provided if applicable and subject to course delivery arrangements.
- Lunch Provided if applicable and subject to course delivery arrangements.

Course Outlines

Week 1
Day 1 – Getting Started with Microsoft Excel

1. Introduction to Excel
- Understanding the Excel interface
- Creating and saving workbooks
- Navigating worksheets and cells

2. Working with Data
- Entering and editing data
- Using AutoFill and basic formatting
- Managing rows, columns, and worksheets

3. Workbook Organisation
- Renaming worksheets
- Moving and copying data
- Applying basic page layouts

Day 2 – Formulas and Functions

1. Basic Formulas
- Mathematical calculations
- Cell references
- Formula copying techniques

2. Essential Functions
- SUM, AVERAGE, MIN, and MAX
- COUNT and COUNTA
- Basic IF function

3. Formatting Data
- Number formats
- Cell styles
- Conditional formatting basics

Day 3 – Managing Data

1. Organising Information
- Creating Excel tables
- Sorting records
- Filtering data

2. Data Validation
- Creating drop-down lists
- Preventing invalid entries
- Input messages and error alerts

3. Finding Information
- Using Find and Replace
- Navigating large worksheets
- Managing worksheet views

Day 4 – Charts and Printing

1. Creating Charts
- Column and bar charts
- Line and pie charts
- Selecting appropriate chart types

2. Formatting Charts
- Editing chart elements
- Adding titles and labels
- Improving chart readability

3. Printing Worksheets
- Page setup
- Print areas
- Headers, footers, and scaling

Day 5 – Practical Excel Workshop

1. Spreadsheet Development Exercise
- Creating a business worksheet
- Applying formulas and formatting
- Organising data effectively

2. Reporting Exercise
- Sorting and filtering information
- Creating charts
- Preparing a printable report

3. Implementation Planning
- Applying Excel skills to daily work
- Identifying opportunities for automation
- Course review, feedback and implementation planning